Previous | Table of Contents | Next |
The following registry keys control the various options that are available within Microsoft Excel 97. Note that to change any of these options, you must exit Excel, change the registry key, then restart Excel.
IV-18 | Hive: | HKEY_CURRENT_USER |
Key: | Software\Microsoft\Office\8.0\Excel\Microsoft Excel | |
Value Name: | DefaultPath | |
Data Type: | REG_SZ | |
Value: | D:\My Documents |
This value sets the default storage location and search path for documents that you create or use in Microsoft Excel 97. This value overrides the path set in the HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders\Personal registry key.
IV-19 | Hive: | HKEY_CURRENT_USER |
Key: | Software\Microsoft\Shared Tools\Outlook\Journaling\ Microsoft Excel | |
Value Name: | Enabled | |
Data Type: | REG_DWORD | |
Value: | 0x1 |
This value controls the Journaling feature in Microsoft Outlook and tracks when and how long you work with any Microsoft Excel Documents.
IV-20 | Hive: | HKEY_CURRENT_USER |
Key: | Software\Microsoft\Office\8.0\Excel\Microsoft Excel | |
Value Name: | Maximized | |
Data Type: | REG_DWORD | |
Value: | 0x3 |
This value controls how Excel displays its window and workbook window when starting up. Note that Excel overwrites this value with its current settings when it exits. You have the following options for this value:
3 | Excel and Workbook window maximized |
2 | Workbook window maximized |
1 | Excel maximized, Workbook window not maximized |
0 | Nothing maximized |
IV-21 | Hive: | HKEY_CURRENT_USER |
Key: | Software\Microsoft\Office\8.0\Excel\Microsoft Excel | |
Value Name: | Pos | |
Data Type: | REG_SZ | |
Value: | left, top, right, bottom |
This value tells Excel how big to make its window and the position of the Top, Left, Right and Bottom corners of its window. An example of a valid value is 66,66,600,411
IV-22 | Hive: | HKEY_CURRENT_USER |
Key: | Software\Microsoft\Office\8.0\Excel\Microsoft Excel | |
Value Name: | Default Chart | |
Data Type: | REG_SZ | |
Value: | <type:charttype, subtype> |
This value sets Excels default chart, which is a two-dimensional column chart. The type can be Standard, Built-in, or User-defined; for the charttype variable, select one of the charts listed in the Chart Type menu on the Chart/Chart Type dialog box. Similarly, for the subtype variable, choose one of the Chart sub-types found in the same dialog box. The default value is Standard:1,1. Note that user-defined chart formats are stored in a file called Xlusrgal.xls, which is located in the Program Files\Microsoft Office\Office folder.
IV-23 | Hive: | HKEY_CURRENT_USER |
Key: | Software\Microsoft\Office\8.0\Excel\Microsoft Excel | |
Value Name: | DefSheets | |
Data Type: | REG_DWORD | |
Value: | 0x3 |
This value tells Excel how many worksheets to create in a new workbook. If you set this to 1, a new workbook contains only one worksheet.
IV-24 | Hive: | HKEY_CURRENT_USER |
Key: | Software\Microsoft\Office\8.0\Excel\Microsoft Excel | |
Value Name: | MoveEnterDir | |
Data Type: | REG_DWORD | |
Value: | 0x1 |
Previous | Table of Contents | Next |